package com.manage.demo.dao;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.manage.demo.dao.model.ExamResults;


@Mapper
public interface ExamResultMapper {
	@Select("select term from exam_results")
	public List<String> getYear();
	
	@Select("select subject_name from subject_info")
	public List<String> getSubject();
	
	@Select("select * from exam_results where term=#{year} and exam_type=#{examtype}")
	public List<ExamResults> getResults(String year, String examtype);
	
}
